Item Balance Reports
Table of Contents
Item Balance Reports
Processing Summary
- Item Balance Reports
- Historical Item Balance Report
Processing Dialog
- From the "Inventory Control" menu, take the option for "Item Balance Reports".
- You are prompted for parameters used by the programming to produce the report information you are looking for.
The following depicts the prompt panel that displays.
Item Balance Reports
Details of parameters on the panel are:
- You must supply a - Storer Number - .
- The - Include Quantities - parameter allows you to select the items to appear on the report. Use the F4 key to see all parameters available.
The following table lists your choices for the Include Quantities option.
| Option | Description |
|---|---|
| *ALL | All items are listed |
| *AVAIL | All items with a quantity in the available bucket are listed. |
| *DAMAGE | All items with a quantity of damaged stock are listed. |
| *HELD | All items with a quantity of damaged stock are listed. |
| *USER1 | All items with a quantity of stock are user defined bucket 1 are listed. |
| *USER2 | All items with a quantity of stock are user defined bucket 2 are listed. |
| *USER3 | All items with a quantity of stock are user defined bucket 3 are listed. |
| *NEGATIVE | All items with a negative quantity in any stock bucket are listed. |
| *OVERALLOC | All items with a soft allocation quantity greater than the stock on hand are listed. |
| *LOWSTOCK | All items at or below their item master low stock quantity are listed. |
| *NONZERO | All items with a quantity in any stock bucket are listed. |
- The - Show Locations - and - Show Lots - parameters allow you to choose whether lot or location details should be listed below each item.
- The - Report Order - allows you to set the order that the items appear on the report.
The following is the list of choices for the Report Order option.
| Option | Description |
|---|---|
| *ITEM | The items are listed in item code sequence. |
| *ITMSEQ | The items are listed in the order you have set for item sequencing. |
| *DESCRIPT | The items are listed in item description sequence. |
| *PROD | The items are listed by item code within product code group. |
- The - Report Units - allow you to determine the units in which the quantity columns are reported. Different units can be an advantage for different reporting needs.
The following is a list of the Quantity units you can choose from.
NOTE : Conversion to pallets or hundred weight or cubic feet is only accurate if the item master records contain accurate conversion units.
| Option | Description |
|---|---|
| *QUANTITY | The quantity is reported in inventory units. |
| *PALLETS | The quantity is reported in pallets. |
| *CASES | The quantity is reported in cases. |
| *CWEIGHT | The quantity is reported in hundred weights. |
| *CUBES | The quantity is reported in cubic feet. |
- The last parameter allows you to set the Title of the report. The text you key appears at the top of each page of the report.
The following depicts a typical report.
A Typical Item Balance Report
- In the headings of the report are the - Date - and - Time - the report was produced and the - User - that requested it.
- The - Title - that you keyed appears at the top and the - Page Number - is on the right.
- The report parameters appear on the following line.
In the body of the report is information on each item. The items are listed in the order that you specified.
- Shown for each is the - Items Code - and - Description - followed by a set of quantity columns.
- The first column is the - Available - quantity. This is the available quantity on hand less any stock currently hard committed to orders.
- The second column is the hard - Committed - quantity.
- The third quantity is the - Allocated - quantity (quantity required for open orders not yet in the picking cycle.)
- Next comes the quantity on open inbound notifications labelled - In Tran Qty - .
- Followed by the quantities - Damaged - , - Held - , and in the three - User Defined - buckets.
- The last column is the - On Hand - quantity which is the total of the available, committed, damaged, held, and three user defined buckets.
- When the options to print - Lots - or - Locations - are selected, a separate line is listed beneath the item breaking out the quantities by location.
- The - Lots - breakout follows the - Location - breakout. In the above example only, the locations were requested.
- A set of - Totals - appears at the bottom of the report. In addition to a count of the items listed, a total is provided for each of the quantity columns.
Historical Item Balance Report
Another type of Item Balance Report that allows a cutoff "as of" a specified date is the "Historical Item Balance Report." This report also supports creating an extract of the balance data and emailing to a specified email address.
Historical Item Balance Report Email Option
The addition of an Email feature to the Historical Item Balance Report allows you to email the report once generated.
- From the option for "Inventory Control," select the option for Historical Item Balance Report. If you do not immediately see it, press the Page Down key to see More...options. Here you will find the option for "Historical Item Balance Report."
- Select this option and press the <Enter> key. The following panel displays:
Historical Item Balance Report - Email Option
Details of the parameters on the panel are the same as the Item Balance Report mentioned above with the following exceptions:
- The - As of Date - allows a cutoff as of a specified date.
- OUTPUT - is included for the *EMAIL option that creates an extract of the balance data and emails it to a specified email address.